﻿<%@ Page Language="C#" AutoEventWireup="true" CodeBehind="Account.aspx.cs" Inherits="_2011DBProject.Account" %>

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<link rel=StyleSheet HREF='design1.css' type='text/css'>
<html xmlns="http://www.w3.org/1999/xhtml" >
<head runat="server">
    <title>새벽 골프</title>
</head>
<body>
    <form id="form1" runat="server">
    <div>
        <p align =left>
        <asp:Button ID="btnGoLogout" runat="server" onclick="btnGoLogout_onclick" 
            Text="☜ 로 그 아 웃" Width="150px" />
        <asp:Button ID="btnGoServer" runat="server" onclick="btnGoServer_onclick" 
            Text="☜ 서 버 선 택" Width="150px" />
            </p>
        <br />
        <asp:Label ID="Label1" runat="server" Font-Size="25pt" 
            ForeColor="#9EDCFF" Text="계정정보 보기 및 수정"></asp:Label>
        <br />
        <asp:GridView ID="gvAccount" runat="server" AutoGenerateColumns="False" DataSourceID="sqldsAccount" 
            EmptyDataText="There are no data records to display." CellPadding="10" 
            ForeColor="#333333" GridLines="None" DataKeyNames="ACCOUNT_ID" HorizontalAlign="Center">
            <RowStyle BackColor="#F7F6F3" ForeColor="#333333" />
            <Columns>
                <asp:CommandField EditText="정보수정" ShowEditButton="True" />
                <asp:BoundField DataField="ACCOUNT_ID" HeaderText="아이디" ReadOnly="True" 
                    SortExpression="ACCOUNT_ID" />
                <asp:BoundField DataField="NAME" HeaderText="이름" SortExpression="NAME" />
                <asp:BoundField DataField="PASSWORD" HeaderText="비밀번호" 
                    SortExpression="PASSWORD" />
                <asp:BoundField DataField="EMAIL" HeaderText="EMAIL" 
                    SortExpression="EMAIL" />
                <asp:BoundField DataField="ADDRESS" HeaderText="주소" 
                    SortExpression="ADDRESS" />
                <asp:BoundField DataField="GRADE_NAME" HeaderText="등급" 
                    SortExpression="GRADE_NAME" ReadOnly="True" />
                <asp:BoundField DataField="PARTNER_SITE" HeaderText="협력사이트" 
                    SortExpression="PARTNER_SITE" ReadOnly="True" />
            </Columns>
            <FooterStyle BackColor="#5D7B9D" Font-Bold="True" ForeColor="White" />
            <PagerStyle BackColor="#284775" ForeColor="White" HorizontalAlign="Center" />
            <SelectedRowStyle BackColor="#E2DED6" Font-Bold="True" ForeColor="#333333" />
            <HeaderStyle BackColor="#5D7B9D" Font-Bold="True" ForeColor="White" />
            <EditRowStyle BackColor="#999999" />
            <AlternatingRowStyle BackColor="White" ForeColor="#284775" />
        </asp:GridView>
        <br />
        <br />
        <br />
        <asp:Label ID="Label7" runat="server" Font-Size="25pt" 
            ForeColor="#9EDCFF" Text="락커룸 아이템 현황"></asp:Label>
        <asp:GridView ID="gvAccountLockerRoom" runat="server" 
            AutoGenerateColumns="False" CellPadding="4" 
            DataSourceID="sqldsAccountLockerRoom" 
            EmptyDataText="There are no data records to display." ForeColor="#333333" 
            GridLines="None" DataKeyNames="ITEM_NO" HorizontalAlign="Center">
            <RowStyle BackColor="#F7F6F3" ForeColor="#333333" />
            <Columns>
                <asp:BoundField DataField="ITEM_NO" HeaderText="아이템번호" 
                    SortExpression="ITEM_NO" ReadOnly="True" />
                <asp:BoundField DataField="ITEM_NAME" HeaderText="아이템이름" 
                    SortExpression="ITEM_NAME" >
                <HeaderStyle Width="200px" />
                </asp:BoundField>
                <asp:BoundField DataField="DURABILITY" HeaderText="내구도" 
                    SortExpression="DURABILITY" />
                <asp:BoundField DataField="IMPACT_CORRECTION" HeaderText="+임팩" 
                    SortExpression="IMPACT_CORRECTION" />
                <asp:BoundField DataField="POWER_CORRECTION" 
                    HeaderText="+파워" SortExpression="POWER_CORRECTION" />
                <asp:BoundField DataField="STRENGTH_CORRECTION" 
                    HeaderText="+힘" SortExpression="STRENGTH_CORRECTION" />
                <asp:BoundField DataField="TECHNIQUE_CORRECTION" HeaderText="+기술" 
                    SortExpression="TECHNIQUE_CORRECTION" />
                <asp:BoundField DataField="QTY" HeaderText="QTY" SortExpression="QTY" 
                    Visible="False" />
            </Columns>
            <FooterStyle BackColor="#5D7B9D" Font-Bold="True" ForeColor="White" />
            <PagerStyle BackColor="#284775" ForeColor="White" HorizontalAlign="Center" />
            <EmptyDataTemplate>
                <br />
                <font color="#ffff99">락커룸에 아이템이 없습니다.</font><br />
            </EmptyDataTemplate>
            <SelectedRowStyle BackColor="#E2DED6" Font-Bold="True" ForeColor="#333333" />
            <HeaderStyle BackColor="#5D7B9D" Font-Bold="True" ForeColor="White" />
            <EditRowStyle BackColor="#999999" />
            <AlternatingRowStyle BackColor="White" ForeColor="#284775" />
        </asp:GridView>
        <br />
        <br />
        <asp:Label ID="Label8" runat="server" Font-Size="25pt" 
            ForeColor="#9EDCFF" Text="계정의 등급혜택"></asp:Label>
        <br />
        <asp:GridView ID="gvService" runat="server" AutoGenerateColumns="False" 
            CellPadding="4" DataSourceID="sqldsGrade" 
            EmptyDataText="There are no data records to display." ForeColor="#333333" 
            GridLines="None" HorizontalAlign="Center">
            <RowStyle BackColor="#F7F6F3" ForeColor="#333333" />
            <Columns>
                <asp:BoundField DataField="GRADE_NAME" HeaderText="등급명" 
                    SortExpression="GRADE_NAME" />
                <asp:BoundField DataField="EXP_RATE" HeaderText="증가경험치율" 
                    SortExpression="EXP_RATE" />
                <asp:BoundField DataField="REWARD_RATE" HeaderText="증가상금율" 
                    SortExpression="REWARD_RATE" />
                <asp:BoundField DataField="GREENFEE_DISC_RATE" HeaderText="그린피할인율" 
                    SortExpression="GREENFEE_DISC_RATE" />
            </Columns>
            <FooterStyle BackColor="#5D7B9D" Font-Bold="True" ForeColor="White" />
            <PagerStyle BackColor="#284775" ForeColor="White" HorizontalAlign="Center" />
            <SelectedRowStyle BackColor="#E2DED6" Font-Bold="True" ForeColor="#333333" />
            <HeaderStyle BackColor="#5D7B9D" Font-Bold="True" ForeColor="White" />
            <EditRowStyle BackColor="#999999" />
            <AlternatingRowStyle BackColor="White" ForeColor="#284775" />
        </asp:GridView>
        <br />
        <br />
        <br />
        <br />
        <br />
        <br />
        <br />
        <br />
        <br />
        <asp:SqlDataSource ID="sqldsGrade" runat="server" 
            ConnectionString="<%$ ConnectionStrings:ConnectionString %>" 
            DeleteCommand="DELETE FROM &quot;GRADE&quot; WHERE &quot;GRADE_NO&quot; = :original_GRADE_NO AND ((&quot;GRADE_NAME&quot; = :original_GRADE_NAME) OR (&quot;GRADE_NAME&quot; IS NULL AND :original_GRADE_NAME IS NULL)) AND ((&quot;EXPERIENCE_RATE&quot; = :original_EXPERIENCE_RATE) OR (&quot;EXPERIENCE_RATE&quot; IS NULL AND :original_EXPERIENCE_RATE IS NULL)) AND ((&quot;REWARD_RATE&quot; = :original_REWARD_RATE) OR (&quot;REWARD_RATE&quot; IS NULL AND :original_REWARD_RATE IS NULL)) AND ((&quot;GREEN_FEE_DISC_RATE&quot; = :original_GREEN_FEE_DISC_RATE) OR (&quot;GREEN_FEE_DISC_RATE&quot; IS NULL AND :original_GREEN_FEE_DISC_RATE IS NULL))" 
            InsertCommand="INSERT INTO &quot;GRADE&quot; (&quot;GRADE_NO&quot;, &quot;GRADE_NAME&quot;, &quot;EXPERIENCE_RATE&quot;, &quot;REWARD_RATE&quot;, &quot;GREEN_FEE_DISC_RATE&quot;) VALUES (:GRADE_NO, :GRADE_NAME, :EXPERIENCE_RATE, :REWARD_RATE, :GREEN_FEE_DISC_RATE)" 
            ProviderName="<%$ ConnectionStrings:ConnectionString.ProviderName %>" 
            SelectCommand="SELECT GRADE_BENEFIT.GRADE_NAME, GRADE_BENEFIT.EXP_RATE, GRADE_BENEFIT.REWARD_RATE, GRADE_BENEFIT.GREENFEE_DISC_RATE FROM &quot;ACCOUNT&quot;, GRADE_BENEFIT WHERE &quot;ACCOUNT&quot;.GRADE_NO = GRADE_BENEFIT.GRADE_NO AND (&quot;ACCOUNT&quot;.ACCOUNT_ID = :ACCOUNT_ID)" 
            
            UpdateCommand="UPDATE &quot;GRADE&quot; SET &quot;GRADE_NAME&quot; = :GRADE_NAME, &quot;EXPERIENCE_RATE&quot; = :EXPERIENCE_RATE, &quot;REWARD_RATE&quot; = :REWARD_RATE, &quot;GREEN_FEE_DISC_RATE&quot; = :GREEN_FEE_DISC_RATE WHERE &quot;GRADE_NO&quot; = :original_GRADE_NO AND ((&quot;GRADE_NAME&quot; = :original_GRADE_NAME) OR (&quot;GRADE_NAME&quot; IS NULL AND :original_GRADE_NAME IS NULL)) AND ((&quot;EXPERIENCE_RATE&quot; = :original_EXPERIENCE_RATE) OR (&quot;EXPERIENCE_RATE&quot; IS NULL AND :original_EXPERIENCE_RATE IS NULL)) AND ((&quot;REWARD_RATE&quot; = :original_REWARD_RATE) OR (&quot;REWARD_RATE&quot; IS NULL AND :original_REWARD_RATE IS NULL)) AND ((&quot;GREEN_FEE_DISC_RATE&quot; = :original_GREEN_FEE_DISC_RATE) OR (&quot;GREEN_FEE_DISC_RATE&quot; IS NULL AND :original_GREEN_FEE_DISC_RATE IS NULL))" 
            ConflictDetection="CompareAllValues" 
            OldValuesParameterFormatString="original_{0}">
            <SelectParameters>
                <asp:SessionParameter Name="ACCOUNT_ID" SessionField="USER" />
            </SelectParameters>
            <DeleteParameters>
                <asp:Parameter Name="original_GRADE_NO" Type="Decimal" />
                <asp:Parameter Name="original_GRADE_NAME" Type="String" />
                <asp:Parameter Name="original_EXPERIENCE_RATE" Type="Decimal" />
                <asp:Parameter Name="original_REWARD_RATE" Type="Decimal" />
                <asp:Parameter Name="original_GREEN_FEE_DISC_RATE" Type="Decimal" />
            </DeleteParameters>
            <InsertParameters>
                <asp:Parameter Name="GRADE_NO" Type="Decimal" />
                <asp:Parameter Name="GRADE_NAME" Type="String" />
                <asp:Parameter Name="EXPERIENCE_RATE" Type="Decimal" />
                <asp:Parameter Name="REWARD_RATE" Type="Decimal" />
                <asp:Parameter Name="GREEN_FEE_DISC_RATE" Type="Decimal" />
            </InsertParameters>
            <UpdateParameters>
                <asp:Parameter Name="GRADE_NAME" Type="String" />
                <asp:Parameter Name="EXPERIENCE_RATE" Type="Decimal" />
                <asp:Parameter Name="REWARD_RATE" Type="Decimal" />
                <asp:Parameter Name="GREEN_FEE_DISC_RATE" Type="Decimal" />
                <asp:Parameter Name="original_GRADE_NO" Type="Decimal" />
                <asp:Parameter Name="original_GRADE_NAME" Type="String" />
                <asp:Parameter Name="original_EXPERIENCE_RATE" Type="Decimal" />
                <asp:Parameter Name="original_REWARD_RATE" Type="Decimal" />
                <asp:Parameter Name="original_GREEN_FEE_DISC_RATE" Type="Decimal" />
            </UpdateParameters>
        </asp:SqlDataSource>
        <asp:SqlDataSource ID="sqldsAccountLockerRoom" runat="server" 
            ConnectionString="<%$ ConnectionStrings:ConnectionString %>" 
            DeleteCommand="DELETE FROM &quot;ACCOUNT_LOCKERROOM&quot; WHERE &quot;SERVER_NO&quot; = :original_SERVER_NO AND &quot;ACCOUNT_ID&quot; = :original_ACCOUNT_ID AND &quot;ITEM_NO&quot; = :original_ITEM_NO AND ((&quot;ITEM_QTY&quot; = :original_ITEM_QTY) OR (&quot;ITEM_QTY&quot; IS NULL AND :original_ITEM_QTY IS NULL))" 
            InsertCommand="INSERT INTO &quot;ACCOUNT_LOCKERROOM&quot; (&quot;ITEM_QTY&quot;, &quot;SERVER_NO&quot;, &quot;ACCOUNT_ID&quot;, &quot;ITEM_NO&quot;) VALUES (:ITEM_QTY, :SERVER_NO, :ACCOUNT_ID, :ITEM_NO)" 
            ProviderName="<%$ ConnectionStrings:ConnectionString.ProviderName %>" 
            SelectCommand="SELECT ITEM.ITEM_NO, ITEM.ITEM_NAME, MY_ITEM.DURABILITY, MY_ITEM.IMPACT_CORRECTION, MY_ITEM.POWER_CORRECTION, MY_ITEM.STRENGTH_CORRECTION, MY_ITEM.TECHNIQUE_CORRECTION, MY_ITEM.QTY FROM MY_ITEM, ITEM WHERE MY_ITEM.ITEM_NO = ITEM.ITEM_NO AND (MY_ITEM.CHARACTER_NAME = :CHARACTER_NAME) AND (MY_ITEM.SERVER_NO = :SERVER) AND (MY_ITEM.LOCKERROOM_KEEP = 'Y')" 
            
            UpdateCommand="UPDATE &quot;ACCOUNT_LOCKERROOM&quot; SET &quot;ITEM_QTY&quot; = :ITEM_QTY WHERE &quot;SERVER_NO&quot; = :original_SERVER_NO AND &quot;ACCOUNT_ID&quot; = :original_ACCOUNT_ID AND &quot;ITEM_NO&quot; = :original_ITEM_NO AND ((&quot;ITEM_QTY&quot; = :original_ITEM_QTY) OR (&quot;ITEM_QTY&quot; IS NULL AND :original_ITEM_QTY IS NULL))" 
            ConflictDetection="CompareAllValues" 
            OldValuesParameterFormatString="original_{0}">
            <SelectParameters>
                <asp:SessionParameter Name="CHARACTER_NAME" SessionField="CHARACTER_NAME" />
                <asp:SessionParameter Name="SERVER" SessionField="SERVER" />
            </SelectParameters>
            <DeleteParameters>
                <asp:Parameter Name="original_SERVER_NO" Type="Decimal" />
                <asp:Parameter Name="original_ACCOUNT_ID" Type="String" />
                <asp:Parameter Name="original_ITEM_NO" Type="Decimal" />
                <asp:Parameter Name="original_ITEM_QTY" Type="Decimal" />
            </DeleteParameters>
            <InsertParameters>
                <asp:Parameter Name="ITEM_QTY" Type="Decimal" />
                <asp:Parameter Name="SERVER_NO" Type="Decimal" />
                <asp:Parameter Name="ACCOUNT_ID" Type="String" />
                <asp:Parameter Name="ITEM_NO" Type="Decimal" />
            </InsertParameters>
            <UpdateParameters>
                <asp:Parameter Name="ITEM_QTY" Type="Decimal" />
                <asp:Parameter Name="original_SERVER_NO" Type="Decimal" />
                <asp:Parameter Name="original_ACCOUNT_ID" Type="String" />
                <asp:Parameter Name="original_ITEM_NO" Type="Decimal" />
                <asp:Parameter Name="original_ITEM_QTY" Type="Decimal" />
            </UpdateParameters>
        </asp:SqlDataSource>
        <asp:SqlDataSource ID="sqldsAccount" runat="server" 
            ConnectionString="<%$ ConnectionStrings:ConnectionString %>" 
            DeleteCommand="DELETE FROM &quot;ACCOUNT&quot; WHERE &quot;ACCOUNT_ID&quot; = :original_ACCOUNT_ID AND ((&quot;SSN&quot; = :original_SSN) OR (&quot;SSN&quot; IS NULL AND :original_SSN IS NULL)) AND ((&quot;NAME&quot; = :original_NAME) OR (&quot;NAME&quot; IS NULL AND :original_NAME IS NULL)) AND ((&quot;EMAIL&quot; = :original_EMAIL) OR (&quot;EMAIL&quot; IS NULL AND :original_EMAIL IS NULL)) AND ((&quot;ADDRESS&quot; = :original_ADDRESS) OR (&quot;ADDRESS&quot; IS NULL AND :original_ADDRESS IS NULL)) AND ((&quot;PASSWORD&quot; = :original_PASSWORD) OR (&quot;PASSWORD&quot; IS NULL AND :original_PASSWORD IS NULL)) AND ((&quot;GRADE_NO&quot; = :original_GRADE_NO) OR (&quot;GRADE_NO&quot; IS NULL AND :original_GRADE_NO IS NULL)) AND ((&quot;PARTNER_SITE_ID&quot; = :original_PARTNER_SITE_ID) OR (&quot;PARTNER_SITE_ID&quot; IS NULL AND :original_PARTNER_SITE_ID IS NULL)) AND &quot;PARTNER_SITE_NO&quot; = :original_PARTNER_SITE_NO" 
            InsertCommand="INSERT INTO &quot;ACCOUNT&quot; (&quot;SSN&quot;, &quot;NAME&quot;, &quot;EMAIL&quot;, &quot;ADDRESS&quot;, &quot;PASSWORD&quot;, &quot;ACCOUNT_ID&quot;, &quot;GRADE_NO&quot;, &quot;PARTNER_SITE_ID&quot;, &quot;PARTNER_SITE_NO&quot;) VALUES (:SSN, :NAME, :EMAIL, :ADDRESS, :PASSWORD, :ACCOUNT_ID, :GRADE_NO, :PARTNER_SITE_ID, :PARTNER_SITE_NO)" 
            ProviderName="<%$ ConnectionStrings:ConnectionString.ProviderName %>" 
            SelectCommand="SELECT &quot;ACCOUNT&quot;.ACCOUNT_ID, &quot;ACCOUNT&quot;.NAME, &quot;ACCOUNT&quot;.PASSWORD, &quot;ACCOUNT&quot;.EMAIL, &quot;ACCOUNT&quot;.ADDRESS, GRADE_BENEFIT.GRADE_NAME, PARTNER_SITE.NAME AS partner_site
FROM &quot;ACCOUNT&quot;, PARTNER_SITE, GRADE_BENEFIT 
WHERE &quot;ACCOUNT&quot;.PARTNER_SITE_NO = PARTNER_SITE.PARTNER_SITE_NO AND &quot;ACCOUNT&quot;.GRADE_NO = GRADE_BENEFIT.GRADE_NO AND (&quot;ACCOUNT&quot;.ACCOUNT_ID = :ACCOUNT_ID)" 
            
            
            UpdateCommand="UPDATE &quot;ACCOUNT&quot; SET &quot;SSN&quot; = :SSN, &quot;NAME&quot; = :NAME, &quot;EMAIL&quot; = :EMAIL, &quot;ADDRESS&quot; = :ADDRESS, &quot;PASSWORD&quot; = :PASSWORD, &quot;GRADE_NO&quot; = :GRADE_NO, &quot;PARTNER_SITE_ID&quot; = :PARTNER_SITE_ID, &quot;PARTNER_SITE_NO&quot; = :PARTNER_SITE_NO WHERE &quot;ACCOUNT_ID&quot; = :original_ACCOUNT_ID AND ((&quot;SSN&quot; = :original_SSN) OR (&quot;SSN&quot; IS NULL AND :original_SSN IS NULL)) AND ((&quot;NAME&quot; = :original_NAME) OR (&quot;NAME&quot; IS NULL AND :original_NAME IS NULL)) AND ((&quot;EMAIL&quot; = :original_EMAIL) OR (&quot;EMAIL&quot; IS NULL AND :original_EMAIL IS NULL)) AND ((&quot;ADDRESS&quot; = :original_ADDRESS) OR (&quot;ADDRESS&quot; IS NULL AND :original_ADDRESS IS NULL)) AND ((&quot;PASSWORD&quot; = :original_PASSWORD) OR (&quot;PASSWORD&quot; IS NULL AND :original_PASSWORD IS NULL)) AND ((&quot;GRADE_NO&quot; = :original_GRADE_NO) OR (&quot;GRADE_NO&quot; IS NULL AND :original_GRADE_NO IS NULL)) AND ((&quot;PARTNER_SITE_ID&quot; = :original_PARTNER_SITE_ID) OR (&quot;PARTNER_SITE_ID&quot; IS NULL AND :original_PARTNER_SITE_ID IS NULL)) AND &quot;PARTNER_SITE_NO&quot; = :original_PARTNER_SITE_NO" 
            ConflictDetection="CompareAllValues" 
            OldValuesParameterFormatString="original_{0}">
            <SelectParameters>
                <asp:SessionParameter DefaultValue="" Name="ACCOUNT_ID" SessionField="USER" 
                    Type="String" />
            </SelectParameters>
            <DeleteParameters>
                <asp:Parameter Name="original_ACCOUNT_ID" Type="String" />
                <asp:Parameter Name="original_SSN" Type="String" />
                <asp:Parameter Name="original_NAME" Type="String" />
                <asp:Parameter Name="original_EMAIL" Type="String" />
                <asp:Parameter Name="original_ADDRESS" Type="String" />
                <asp:Parameter Name="original_PASSWORD" Type="String" />
                <asp:Parameter Name="original_GRADE_NO" Type="Decimal" />
                <asp:Parameter Name="original_PARTNER_SITE_ID" Type="String" />
                <asp:Parameter Name="original_PARTNER_SITE_NO" Type="Decimal" />
            </DeleteParameters>
            <UpdateParameters>
                <asp:Parameter Name="SSN" Type="String" />
                <asp:Parameter Name="NAME" Type="String" />
                <asp:Parameter Name="EMAIL" Type="String" />
                <asp:Parameter Name="ADDRESS" Type="String" />
                <asp:Parameter Name="PASSWORD" Type="String" />
                <asp:Parameter Name="GRADE_NO" Type="Decimal" />
                <asp:Parameter Name="PARTNER_SITE_ID" Type="String" />
                <asp:Parameter Name="PARTNER_SITE_NO" Type="Decimal" />
                <asp:Parameter Name="original_ACCOUNT_ID" Type="String" />
                <asp:Parameter Name="original_SSN" Type="String" />
                <asp:Parameter Name="original_NAME" Type="String" />
                <asp:Parameter Name="original_EMAIL" Type="String" />
                <asp:Parameter Name="original_ADDRESS" Type="String" />
                <asp:Parameter Name="original_PASSWORD" Type="String" />
                <asp:Parameter Name="original_GRADE_NO" Type="Decimal" />
                <asp:Parameter Name="original_PARTNER_SITE_ID" Type="String" />
                <asp:Parameter Name="original_PARTNER_SITE_NO" Type="Decimal" />
            </UpdateParameters>
            <InsertParameters>
                <asp:Parameter Name="SSN" Type="String" />
                <asp:Parameter Name="NAME" Type="String" />
                <asp:Parameter Name="EMAIL" Type="String" />
                <asp:Parameter Name="ADDRESS" Type="String" />
                <asp:Parameter Name="PASSWORD" Type="String" />
                <asp:Parameter Name="ACCOUNT_ID" Type="String" />
                <asp:Parameter Name="GRADE_NO" Type="Decimal" />
                <asp:Parameter Name="PARTNER_SITE_ID" Type="String" />
                <asp:Parameter Name="PARTNER_SITE_NO" Type="Decimal" />
            </InsertParameters>
        </asp:SqlDataSource>
    <asp:SqlDataSource ID="sqldsServer" runat="server" 
        ConnectionString="<%$ ConnectionStrings:ConnectionString %>" 
        DeleteCommand="DELETE FROM &quot;SERVER&quot; WHERE &quot;SERVER_NO&quot; = :SERVER_NO" 
        InsertCommand="INSERT INTO &quot;SERVER&quot; (&quot;SERVER_NAME&quot;, &quot;SERVER_NO&quot;) VALUES (:SERVER_NAME, :SERVER_NO)" 
        ProviderName="<%$ ConnectionStrings:ConnectionString.ProviderName %>" 
        SelectCommand="SELECT &quot;SERVER_NAME&quot;, &quot;SERVER_NO&quot; FROM &quot;SERVER&quot;" 
        UpdateCommand="UPDATE &quot;SERVER&quot; SET &quot;SERVER_NAME&quot; = :SERVER_NAME WHERE &quot;SERVER_NO&quot; = :SERVER_NO">
        <DeleteParameters>
            <asp:Parameter Name="SERVER_NO" Type="Decimal" />
        </DeleteParameters>
        <InsertParameters>
            <asp:Parameter Name="SERVER_NAME" Type="String" />
            <asp:Parameter Name="SERVER_NO" Type="Decimal" />
        </InsertParameters>
        <UpdateParameters>
            <asp:Parameter Name="SERVER_NAME" Type="String" />
            <asp:Parameter Name="SERVER_NO" Type="Decimal" />
        </UpdateParameters>
    </asp:SqlDataSource>
        <br />
    
    </div>
    </form>
</body>
</html>
